FO_Types_Container
This table requires a single record for each container code. Its purpose is to provide the associated relationships between a container, storage, and specimen. Container volume and aliquot container are also utilized during container management.
Create a container code called “NOLABEL” which is applied to orderable test codes that do not require a label to print. “NOLABEL” is specifically recognized by the FAST system.
Field | Type | Notes |
---|---|---|
Container_ID |
numeric(18, 0) |
ID field, a counter. Unique |
SourceSystem |
varchar(500) |
Future use. |
Code |
varchar(20) |
Enter a unique container code. |
Name |
varchar(50) |
Description of container code. |
GroupCodes |
varchar(255) |
Enter a valid container group code. Containers with like group codes can be combined together in determining container ID. |
StorageCode |
varchar(255) |
Represents a list of acceptable storage temperatures, as storage codes, for the container code. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid storage codes separated by pipes; codes as defined in the FO_Types_Storage table. IE: |StorageCode1|StorageCode2|StorageCode3| |
SpecimenCode |
varchar(255) |
Represents a list of acceptable specimen codes for the container code. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid specimen codes separated by pipes; codes as defined in the FO_Types_Specimen table. IE: |SpecimenCode1|SpecimenCode2|SpecimenCode3| |
ContainerVolume |
numeric(18, 0) |
Maximum volume allowed for container before a new container ID should be generated. Enter an integer for the maximum volume. |
AliquoteContainerCodes |
varchar(255) |
Represents a list of acceptable aliquot container codes for the container code. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid aliquot container codes separated by pipes; codes as defined in the FO_Types_Container table. IE: |ContainerCode1|ContainerCode2|ContainerCode3| |
LabelFormatID |
varchar(50) |
Future use. |
LabelSequence |
varchar(50) |
Enter a string to control the label sequence for the container type printed on labels. Use the same number of characters in all records so alphanumeric sequencing is effective. |
CreateDate |
datetime |
Date record was created. Informational |
CreateUser |
varchar(50) |
User who created record. Informational |
EditDate |
datetime |
Date record was last edited. Informational |
EditUser |
varchar(50) |
User who last edited record. Informational |